BEGIN;

CREATE TABLE event (
    id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	object_state VARCHAR(30) NOT NULL,
	sid VARCHAR(32) NOT NULL,
	name VARCHAR(50) NOT NULL,
	room_id INT(11) NOT NULL,
	date_time TIMESTAMP NOT NULL,
	description TEXT,
	price DOUBLE,
	FOREIGN KEY (room_id) REFERENCES room(id) ON DELETE CASCADE,
	UNIQUE (sid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

COMMIT;